<?php
//=======================================
//###################################
// Kayako Web Solutions
//
// Source Copyright 2001-2004 Kayako Infotech Ltd.
// Unauthorized reproduction is not allowed
// License Number: $%LICENSE%$
// $Author: vshoor $ ($Date: 2006/08/18 18:29:41 $)
// $RCSfile: upgrade.php,v $ : $Revision: 1.1 $ 
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
//
//###################################
//=======================================

if (!defined("INSWIFT")) {
	trigger_error("Unable to process $PHP_SELF", E_USER_ERROR);
}

// Delete Bug Fix
if (in_array(MODULE_TICKETS, $registeredmodules))
{
		$_SWIFT["query"]["create"]["escalationpaths"] = "CREATE TABLE ". TABLE_PREFIX ."escalationpaths (
																		escalationpathid INT UNSIGNED NOT NULL AUTO_INCREMENT,
																		dateline INT UNSIGNED NOT NULL DEFAULT '0',
																		ticketid INT UNSIGNED NOT NULL DEFAULT '0',
																		slaplanid INT UNSIGNED NOT NULL DEFAULT '0',
																		escalationruleid INT UNSIGNED NOT NULL DEFAULT '0',
																		ownerstaffid INT UNSIGNED NOT NULL DEFAULT '0',
																		departmentid INT UNSIGNED NOT NULL DEFAULT '0',
																		ticketstatusid INT UNSIGNED NOT NULL DEFAULT '0',
																		priorityid INT UNSIGNED NOT NULL DEFAULT '0',
																		flagtype SMALLINT(1) UNSIGNED NOT NULL DEFAULT '0',
																		PRIMARY KEY (escalationpathid),
																		KEY escalationpaths1 (ticketid)
																	);";
}



upgrade_updateVersion("3.00.98");
?>